/*
 Navicat Premium Data Transfer

 Source Server         : 192.168.1.53-3308
 Source Server Type    : MySQL
 Source Server Version : 80031
 Source Host           : 192.168.1.53:3308
 Source Schema         : yygh_order

 Target Server Type    : MySQL
 Target Server Version : 80031
 File Encoding         : 65001

 Date: 09/11/2022 10:45:30
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for order_info
-- ----------------------------
DROP TABLE IF EXISTS `order_info`;
CREATE TABLE `order_info` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
  `user_id` bigint DEFAULT NULL,
  `out_trade_no` varchar(300) DEFAULT NULL COMMENT '订单交易号',
  `hoscode` varchar(30) DEFAULT NULL COMMENT '医院编号',
  `hosname` varchar(100) DEFAULT NULL COMMENT '医院名称',
  `depcode` varchar(30) DEFAULT NULL COMMENT '科室编号',
  `depname` varchar(20) DEFAULT NULL COMMENT '科室名称',
  `title` varchar(20) DEFAULT NULL COMMENT '医生职称',
  `schedule_id` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '排班编号（医院自己的排班主键）',
  `reserve_date` date DEFAULT NULL COMMENT '安排日期',
  `reserve_time` tinyint DEFAULT '0' COMMENT '安排时间（0：上午 1：下午）',
  `patient_id` bigint DEFAULT NULL COMMENT '就诊人id',
  `patient_name` varchar(20) DEFAULT NULL COMMENT '就诊人名称',
  `patient_phone` varchar(11) DEFAULT NULL COMMENT '就诊人手机',
  `hos_record_id` varchar(30) DEFAULT NULL COMMENT '预约记录唯一标识（医院预约记录主键）',
  `number` int DEFAULT NULL COMMENT '预约号序',
  `fetch_time` varchar(50) DEFAULT NULL COMMENT '建议取号时间',
  `fetch_address` varchar(255) DEFAULT NULL COMMENT '取号地点',
  `amount` decimal(10,0) DEFAULT NULL COMMENT '医事服务费',
  `quit_time` datetime DEFAULT NULL COMMENT '退号时间',
  `order_status` tinyint DEFAULT NULL COMMENT '订单状态',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `is_deleted` tinyint NOT NULL DEFAULT '0' COMMENT '逻辑删除(1:已删除，0:未删除)',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_out_trade_no` (`out_trade_no`),
  KEY `idx_user_id` (`user_id`),
  KEY `idx_hoscode` (`hoscode`),
  KEY `idx_hos_schedule_id` (`schedule_id`),
  KEY `idx_hos_record_id` (`hos_record_id`)
) ENGINE=InnoDB AUTO_INCREMENT=78 DEFAULT CHARSET=utf8mb3 COMMENT='订单表';

-- ----------------------------
-- Records of order_info
-- ----------------------------
BEGIN;
INSERT INTO `order_info` (`id`, `user_id`, `out_trade_no`, `hoscode`, `hosname`, `depcode`, `depname`, `title`, `schedule_id`, `reserve_date`, `reserve_time`, `patient_id`, `patient_name`, `patient_phone`, `hos_record_id`, `number`, `fetch_time`, `fetch_address`, `amount`, `quit_time`, `order_status`, `create_time`, `update_time`, `is_deleted`) VALUES (30, 13, '166773173363780', '1000_0', '北京协和医院', '200040878', '精神疾病科', '副主任医师', '636390467e0a5231025a4b8d', '2022-11-07', 0, 9, '李玉祥', '15038651933', '22', 23, '2022-11-0809:00前', '一层114窗口', 100, '2022-11-09 15:30:00', 1, '2022-11-06 10:48:54', '2022-11-08 07:01:21', 0);
INSERT INTO `order_info` (`id`, `user_id`, `out_trade_no`, `hoscode`, `hosname`, `depcode`, `depname`, `title`, `schedule_id`, `reserve_date`, `reserve_time`, `patient_id`, `patient_name`, `patient_phone`, `hos_record_id`, `number`, `fetch_time`, `fetch_address`, `amount`, `quit_time`, `order_status`, `create_time`, `update_time`, `is_deleted`) VALUES (32, 13, '166773295209764', '1000_0', '北京协和医院', '200040878', '精神疾病科', '副主任医师', '636390467e0a5231025a4b8d', '2022-11-07', 0, 9, '李玉祥', '15038651933', '24', 25, '2022-11-0809:00前', '一层114窗口', 100, '2022-11-09 15:30:00', 1, '2022-11-06 11:09:12', '2022-11-08 06:26:31', 0);
INSERT INTO `order_info` (`id`, `user_id`, `out_trade_no`, `hoscode`, `hosname`, `depcode`, `depname`, `title`, `schedule_id`, `reserve_date`, `reserve_time`, `patient_id`, `patient_name`, `patient_phone`, `hos_record_id`, `number`, `fetch_time`, `fetch_address`, `amount`, `quit_time`, `order_status`, `create_time`, `update_time`, `is_deleted`) VALUES (33, 13, '16677331155823', '1000_0', '北京协和医院', '200040878', '精神疾病科', '副主任医师', '636390467e0a5231025a4b8d', '2022-11-09', 0, 9, '李玉祥', '15038651933', '25', 26, '2022-11-0809:00前', '一层114窗口', 100, '2022-11-09 15:30:00', 1, '2022-11-06 11:11:55', '2022-11-09 01:17:10', 0);
INSERT INTO `order_info` (`id`, `user_id`, `out_trade_no`, `hoscode`, `hosname`, `depcode`, `depname`, `title`, `schedule_id`, `reserve_date`, `reserve_time`, `patient_id`, `patient_name`, `patient_phone`, `hos_record_id`, `number`, `fetch_time`, `fetch_address`, `amount`, `quit_time`, `order_status`, `create_time`, `update_time`, `is_deleted`) VALUES (34, 13, '166773415911448', '1000_0', '北京协和医院', '200040878', '精神疾病科', '副主任医师', '636390467e0a5231025a4b8d', '2022-11-07', 0, 10, '李毛学长', '15660879068', '26', 27, '2022-11-0809:00前', '一层114窗口', 100, '2022-11-09 15:30:00', -1, '2022-11-06 11:29:19', '2022-11-08 06:26:40', 0);
INSERT INTO `order_info` (`id`, `user_id`, `out_trade_no`, `hoscode`, `hosname`, `depcode`, `depname`, `title`, `schedule_id`, `reserve_date`, `reserve_time`, `patient_id`, `patient_name`, `patient_phone`, `hos_record_id`, `number`, `fetch_time`, `fetch_address`, `amount`, `quit_time`, `order_status`, `create_time`, `update_time`, `is_deleted`) VALUES (35, 13, '166773490368653', '1000_0', '北京协和医院', '200040878', '精神疾病科', '副主任医师', '636390467e0a5231025a4b8d', '2022-11-07', 0, 9, '李玉祥', '15038651933', '27', 28, '2022-11-0809:00前', '一层114窗口', 100, '2022-11-09 15:30:00', -1, '2022-11-06 11:41:44', '2022-11-08 06:26:45', 0);
INSERT INTO `order_info` (`id`, `user_id`, `out_trade_no`, `hoscode`, `hosname`, `depcode`, `depname`, `title`, `schedule_id`, `reserve_date`, `reserve_time`, `patient_id`, `patient_name`, `patient_phone`, `hos_record_id`, `number`, `fetch_time`, `fetch_address`, `amount`, `quit_time`, `order_status`, `create_time`, `update_time`, `is_deleted`) VALUES (36, 13, '166773509925552', '1000_0', '北京协和医院', '200040878', '精神疾病科', '副主任医师', '636390467e0a5231025a4b8d', '2022-11-07', 0, 9, '李玉祥', '15038651933', '28', 29, '2022-11-0809:00前', '一层114窗口', 100, '2022-11-09 15:30:00', -1, '2022-11-06 11:44:59', '2022-11-08 06:26:48', 0);
INSERT INTO `order_info` (`id`, `user_id`, `out_trade_no`, `hoscode`, `hosname`, `depcode`, `depname`, `title`, `schedule_id`, `reserve_date`, `reserve_time`, `patient_id`, `patient_name`, `patient_phone`, `hos_record_id`, `number`, `fetch_time`, `fetch_address`, `amount`, `quit_time`, `order_status`, `create_time`, `update_time`, `is_deleted`) VALUES (38, 13, '166787890029114', '1000_0', '北京协和医院', '200040878', '精神疾病科', '副主任医师', '636390467e0a5231025a4b8d', '2022-11-08', 0, 9, '李玉祥', '15038651933', '29', 30, '2022-11-0809:00前', '一层114窗口', 100, '2022-11-09 15:30:00', -1, '2022-11-08 03:41:40', '2022-11-08 03:46:54', 0);
INSERT INTO `order_info` (`id`, `user_id`, `out_trade_no`, `hoscode`, `hosname`, `depcode`, `depname`, `title`, `schedule_id`, `reserve_date`, `reserve_time`, `patient_id`, `patient_name`, `patient_phone`, `hos_record_id`, `number`, `fetch_time`, `fetch_address`, `amount`, `quit_time`, `order_status`, `create_time`, `update_time`, `is_deleted`) VALUES (39, 13, '166788313796695', '1000_0', '北京协和医院', '200040878', '精神疾病科', '副主任医师', '636390547e0a5231025a4b91', '2022-11-10', 1, 9, '李玉祥', '15038651933', '30', 31, '2022-11-1009:00前', '一层114窗口', 100, '2022-11-09 15:30:00', -1, '2022-11-08 04:52:18', '2022-11-08 04:52:20', 0);
INSERT INTO `order_info` (`id`, `user_id`, `out_trade_no`, `hoscode`, `hosname`, `depcode`, `depname`, `title`, `schedule_id`, `reserve_date`, `reserve_time`, `patient_id`, `patient_name`, `patient_phone`, `hos_record_id`, `number`, `fetch_time`, `fetch_address`, `amount`, `quit_time`, `order_status`, `create_time`, `update_time`, `is_deleted`) VALUES (40, 13, '166788321026098', '1000_0', '北京协和医院', '200040878', '精神疾病科', '副主任医师', '636390547e0a5231025a4b91', '2022-11-10', 1, 9, '李玉祥', '15038651933', '31', 32, '2022-11-1009:00前', '一层114窗口', 100, '2022-11-09 15:30:00', -1, '2022-11-08 04:53:30', '2022-11-08 12:53:54', 0);
INSERT INTO `order_info` (`id`, `user_id`, `out_trade_no`, `hoscode`, `hosname`, `depcode`, `depname`, `title`, `schedule_id`, `reserve_date`, `reserve_time`, `patient_id`, `patient_name`, `patient_phone`, `hos_record_id`, `number`, `fetch_time`, `fetch_address`, `amount`, `quit_time`, `order_status`, `create_time`, `update_time`, `is_deleted`) VALUES (75, 13, '166790792827016', '1000_0', '北京协和医院', '200040878', '精神疾病科', '副主任医师', '636390647e0a5231025a4b96', '2022-11-13', 0, 9, '李玉祥', '15038651933', '32', -6, '2022-11-1309:00前', '一层114窗口', 100, '2022-11-12 15:30:00', -1, '2022-11-08 11:45:28', '2022-11-08 11:45:29', 0);
INSERT INTO `order_info` (`id`, `user_id`, `out_trade_no`, `hoscode`, `hosname`, `depcode`, `depname`, `title`, `schedule_id`, `reserve_date`, `reserve_time`, `patient_id`, `patient_name`, `patient_phone`, `hos_record_id`, `number`, `fetch_time`, `fetch_address`, `amount`, `quit_time`, `order_status`, `create_time`, `update_time`, `is_deleted`) VALUES (76, 13, '166790806040058', '1000_0', '北京协和医院', '200040878', '精神疾病科', '副主任医师', '636390647e0a5231025a4b96', '2022-11-13', 0, 9, '李玉祥', '15038651933', '33', -5, '2022-11-1309:00前', '一层114窗口', 100, '2022-11-12 15:30:00', -1, '2022-11-08 11:47:41', '2022-11-08 19:48:24', 0);
INSERT INTO `order_info` (`id`, `user_id`, `out_trade_no`, `hoscode`, `hosname`, `depcode`, `depname`, `title`, `schedule_id`, `reserve_date`, `reserve_time`, `patient_id`, `patient_name`, `patient_phone`, `hos_record_id`, `number`, `fetch_time`, `fetch_address`, `amount`, `quit_time`, `order_status`, `create_time`, `update_time`, `is_deleted`) VALUES (77, 14, '166795577768622', '1000_0', '北京协和医院', '200040878', '精神疾病科', '医师', '6363906a7e0a5231025a4b98', '2022-11-09', 0, 11, '白昊祎', '15138751216', '34', -4, '2022-11-1409:00前', '一层114窗口', 100, '2022-11-13 15:30:00', 1, '2022-11-09 01:02:59', '2022-11-09 01:17:18', 0);
COMMIT;

-- ----------------------------
-- Table structure for payment_info
-- ----------------------------
DROP TABLE IF EXISTS `payment_info`;
CREATE TABLE `payment_info` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '编号',
  `out_trade_no` varchar(30) DEFAULT NULL COMMENT '对外业务编号',
  `order_id` bigint DEFAULT NULL COMMENT '订单id',
  `payment_type` tinyint(1) DEFAULT NULL COMMENT '支付类型（微信 支付宝）',
  `trade_no` varchar(50) DEFAULT NULL COMMENT '交易编号',
  `total_amount` decimal(10,2) DEFAULT NULL COMMENT '支付金额',
  `subject` varchar(200) DEFAULT NULL COMMENT '交易内容',
  `payment_status` tinyint DEFAULT NULL COMMENT '支付状态',
  `callback_time` datetime DEFAULT NULL COMMENT '回调时间',
  `callback_content` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci COMMENT '回调信息',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `is_deleted` tinyint NOT NULL DEFAULT '0' COMMENT '逻辑删除(1:已删除，0:未删除)',
  PRIMARY KEY (`id`),
  KEY `idx_out_trade_no` (`out_trade_no`),
  KEY `idx_order_id` (`order_id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb3 COMMENT='支付信息表';

-- ----------------------------
-- Records of payment_info
-- ----------------------------
BEGIN;
INSERT INTO `payment_info` (`id`, `out_trade_no`, `order_id`, `payment_type`, `trade_no`, `total_amount`, `subject`, `payment_status`, `callback_time`, `callback_content`, `create_time`, `update_time`, `is_deleted`) VALUES (22, '166773173363780', 30, 1, '2022110622001488231448486968', 0.01, '2022-11-08|北京协和医院|精神疾病科|副主任医师', 2, '2022-11-06 19:16:25', '{gmt_create=2022-11-06 18:49:19, charset=GBK, seller_email=1597307923@qq.com, subject=????, sign=QukGtxhWC0B/ksOgQUsZddmR4ft5ZdEFglgs2KjsErKC9Ss8nHG1lZs7M5nCbNXHhIjAAxusnCoEBnpyaM03PE3Xh71Rprso/rpnt1un8qZY1pRDbSKPdz4Q2kbMi96o85Vt9tfa+/+LdQkRzPENYO4F7pCl/DVTSYS0LRlOhJYO5Qzx5SFZVBSNlF89a4G2K91fkulvIkgx1XduPdyfYsXNNMXHNY6BYUN2UCoX5TZ9udoBZct0q9oN3dXrUQHiR1I/+B4HgCDMnoE2LlI3KODuq94sjUWT6EpOwJvlMchVhdimHkxV+i9wD2hPiXMDacrf7H2C33cPoWLDfTy0BA==, buyer_id=2088522087388230, invoice_amount=0.01, notify_id=2022110601222184930088231406541993, fund_bill_list=[{\"amount\":\"0.01\",\"fundChannel\":\"ALIPAYACCOUNT\"}], notify_type=trade_status_sync, trade_status=TRADE_SUCCESS, receipt_amount=0.01, buyer_pay_amount=0.01, app_id=2021003142665707, sign_type=RSA2, seller_id=2088422205183375, gmt_payment=2022-11-06 18:49:30, notify_time=2022-11-06 19:15:43, version=1.0, out_trade_no=166773173363780, total_amount=0.01, trade_no=2022110622001488231448486968, auth_app_id=2021003142665707, buyer_logon_id=204***@qq.com, point_amount=0.00}', '2022-11-06 18:49:13', '2022-11-08 02:54:31', 0);
INSERT INTO `payment_info` (`id`, `out_trade_no`, `order_id`, `payment_type`, `trade_no`, `total_amount`, `subject`, `payment_status`, `callback_time`, `callback_content`, `create_time`, `update_time`, `is_deleted`) VALUES (24, '166773295209764', 32, 1, '2022110622001488231449760681', 0.01, '2022-11-08|北京协和医院|精神疾病科|副主任医师', 2, '2022-11-06 19:24:34', '{gmt_create=2022-11-06 19:09:59, charset=GBK, seller_email=1597307923@qq.com, subject=????, sign=HKY84sTQRdnZJROW2osi3hxzRUe8TJZ0rveXEh2IV/QbSBECBKzNokaaZbAiR/FeEJYwES9rb1h6ndplojdoTAr4Tbx8n5QAomRcRvWeDOVLQN6l+x5JZY0rH9tlD3kzg9zHUIIzYKmVbFMiron0Y/LwpGhXGXU8ITPFQGKbLWuN2Mh95Iebuq747dL+pX8GAHK8J4n/g0g5bbQnOnCmhYos4/b+Oix5Q+XS9F6orljxqnlQlCXhH0UXLwEyKR5JtX4asclLKpC9QzUmYfrNhbkWexqXjv46/JAnlvZpwQz8YaIEfrAfCMm5MLVyOnlgZn6vgRI6vcPOJy7DbjTyPA==, buyer_id=2088522087388230, invoice_amount=0.01, notify_id=2022110601222191002088231406203222, fund_bill_list=[{\"amount\":\"0.01\",\"fundChannel\":\"ALIPAYACCOUNT\"}], notify_type=trade_status_sync, trade_status=TRADE_SUCCESS, receipt_amount=0.01, buyer_pay_amount=0.01, app_id=2021003142665707, sign_type=RSA2, seller_id=2088422205183375, gmt_payment=2022-11-06 19:10:02, notify_time=2022-11-06 19:24:32, version=1.0, out_trade_no=166773295209764, total_amount=0.01, trade_no=2022110622001488231449760681, auth_app_id=2021003142665707, buyer_logon_id=204***@qq.com, point_amount=0.00}', '2022-11-06 19:09:51', '2022-11-08 02:54:31', 0);
INSERT INTO `payment_info` (`id`, `out_trade_no`, `order_id`, `payment_type`, `trade_no`, `total_amount`, `subject`, `payment_status`, `callback_time`, `callback_content`, `create_time`, `update_time`, `is_deleted`) VALUES (25, '16677331155823', 33, 1, '2022110622001488231449595733', 0.01, '2022-11-08|北京协和医院|精神疾病科|副主任医师', 2, '2022-11-06 19:13:37', '{gmt_create=2022-11-06 19:12:56, charset=GBK, seller_email=1597307923@qq.com, subject=????, sign=f9M4mUwk9pCYTTpBnWZ2HEaTKZdl4G4g6i8HZNjx7oZfp5D5IjzIj90KaM7/pP3qh+MAeef4t8o4l6DxB7g5sU+uzLR6jADb/TynlSll5A8gRdDlgcHrkRcFjGc3Gd1brMxVKsmeimxilhzwqLjxMq9dnWYu65rSf2S/rSHBVQq/SuvM71VmlXbmlN/4J+qsaupIx00xuWZ+58RswalSedGIn3+WqNAISallAkJrqJ9gEHpabidIkYAqrQHV8S/mft/pzMuobN/R/IQRfVO+Nh+KcrEDHCL1mKTFESk5wlhk5idF76YFfbafXB8+OBFnuppUoCfCq43lZr6h/suOkA==, buyer_id=2088522087388230, invoice_amount=0.01, notify_id=2022110601222191259088231408646070, fund_bill_list=[{\"amount\":\"0.01\",\"fundChannel\":\"ALIPAYACCOUNT\"}], notify_type=trade_status_sync, trade_status=TRADE_SUCCESS, receipt_amount=0.01, buyer_pay_amount=0.01, app_id=2021003142665707, sign_type=RSA2, seller_id=2088422205183375, gmt_payment=2022-11-06 19:12:59, notify_time=2022-11-06 19:13:32, version=1.0, out_trade_no=16677331155823, total_amount=0.01, trade_no=2022110622001488231449595733, auth_app_id=2021003142665707, buyer_logon_id=204***@qq.com, point_amount=0.00}', '2022-11-06 19:12:39', '2022-11-08 02:54:32', 0);
INSERT INTO `payment_info` (`id`, `out_trade_no`, `order_id`, `payment_type`, `trade_no`, `total_amount`, `subject`, `payment_status`, `callback_time`, `callback_content`, `create_time`, `update_time`, `is_deleted`) VALUES (26, '166773415911448', 34, 1, '2022110622001488231448862068', 0.01, '2022-11-08|北京协和医院|精神疾病科|副主任医师', 2, '2022-11-06 19:44:34', '{gmt_create=2022-11-06 19:29:35, charset=GBK, seller_email=1597307923@qq.com, subject=????, sign=HyYc15RCDWpbBuC6w/Jhe7FcTNvslb8Vk3z1YF7+2McNDwasoYt/QiNt/HarzSf67YERTg4TSvdae7qMIpnSAYmLKOBDFoijAe4/l3z/5J9MBdBJeXqmrdm97SAoLIMXljDcpzaE6tx2s05gW404k2HoohM7g/ghzPtzd6UPM5pioclHo9pSLHBOfg8QUscpMX+l08bWFP/nt5YtFQdmqzIdZi9oO9UeAum+10q1krduvlgl0MKZh9nMH5l+aLALqvxoGlOx+CgubKHHsuogfvH5dGBX+Kibd63W+sb+Ms5fqpIJZx7Mazfx/fMWVpVWnkd+fp05q8FmAIOiEnvtrA==, buyer_id=2088522087388230, invoice_amount=0.01, notify_id=2022110601222192938088231408174771, fund_bill_list=[{\"amount\":\"0.01\",\"fundChannel\":\"ALIPAYACCOUNT\"}], notify_type=trade_status_sync, trade_status=TRADE_SUCCESS, receipt_amount=0.01, buyer_pay_amount=0.01, app_id=2021003142665707, sign_type=RSA2, seller_id=2088422205183375, gmt_payment=2022-11-06 19:29:38, notify_time=2022-11-06 19:44:33, version=1.0, out_trade_no=166773415911448, total_amount=0.01, trade_no=2022110622001488231448862068, auth_app_id=2021003142665707, buyer_logon_id=204***@qq.com, point_amount=0.00}', '2022-11-06 19:29:34', '2022-11-08 02:54:32', 0);
INSERT INTO `payment_info` (`id`, `out_trade_no`, `order_id`, `payment_type`, `trade_no`, `total_amount`, `subject`, `payment_status`, `callback_time`, `callback_content`, `create_time`, `update_time`, `is_deleted`) VALUES (27, '166773490368653', 35, 1, '2022110622001488231449627387', 0.01, '2022-11-08|北京协和医院|精神疾病科|副主任医师', 2, '2022-11-06 19:46:06', '{gmt_create=2022-11-06 19:42:05, charset=GBK, seller_email=1597307923@qq.com, subject=????, sign=WTxYDPtmcwGxAgxtU8P4Zxj1l+uEPc7Sg/HOeXN1GQDPHUqi0ABAfw8DRoqgQ7tpPB9S3ystdqUxGEZxMammrnorfwWpThuG3WIbZ56WrpSxUcte4ct5h1r7eOHcnmmR0mUHYwLgIT+oLQXUDoyZa6JN36jEizC3Q+oX3S4L944/WHkBzZkwEIIPP8DFUCKH0iaM3cHBEk0l5jyOFknEjYufc4sN5J7jYdsUu2aAc/BdsvF6WWJ7mwOnCbH1/AXTeG6J+mJA26nx6tkvGaZa5OGAztr0vTdmllocW9UnDOa9L3xgmXOIugDaNHJj8fi38hU+muPIV9o8ti+EnpSpEA==, buyer_id=2088522087388230, invoice_amount=0.01, notify_id=2022110601222194208088231406280980, fund_bill_list=[{\"amount\":\"0.01\",\"fundChannel\":\"ALIPAYACCOUNT\"}], notify_type=trade_status_sync, trade_status=TRADE_SUCCESS, receipt_amount=0.01, buyer_pay_amount=0.01, app_id=2021003142665707, sign_type=RSA2, seller_id=2088422205183375, gmt_payment=2022-11-06 19:42:07, notify_time=2022-11-06 19:46:03, version=1.0, out_trade_no=166773490368653, total_amount=0.01, trade_no=2022110622001488231449627387, auth_app_id=2021003142665707, buyer_logon_id=204***@qq.com, point_amount=0.00}', '2022-11-06 19:42:03', '2022-11-08 02:54:32', 0);
INSERT INTO `payment_info` (`id`, `out_trade_no`, `order_id`, `payment_type`, `trade_no`, `total_amount`, `subject`, `payment_status`, `callback_time`, `callback_content`, `create_time`, `update_time`, `is_deleted`) VALUES (28, '166773509925552', 36, 1, '2022110622001488231448862073', 0.01, '2022-11-08|北京协和医院|精神疾病科|副主任医师', 2, '2022-11-06 19:45:19', '{gmt_create=2022-11-06 19:45:13, charset=GBK, seller_email=1597307923@qq.com, subject=????, sign=j+iQ5Yedboo1ibtkCpDI6LjvQI6yHpk4sGstA2wSegwuo9ZWccrJHnZDscA/JrKCAr2OhyjPA7YWZopQWGSJAjUzPjroJeY+REg63Z8tnC8IcHzki7ALe5uVwR+poBDVau0nRPhCnttglUnZS0FV1G06DQImWbzjYOwYWKGdVqiSMfGU1N8wM+5vmIpMLyCfJIEn9QoGf5Oe1h0hL8kpJ8YJzqTa9MgEIwAjujcEvbwn+rl3gUll0QQ6NK4w20hIgyMjelu1AGbqtuYeJxI25VReVhVp7chQV3sSEwOnjZi+AxNBlh6VXD/vaD1R7fJqPNyyauBGvkfJvIiAc/7Byw==, buyer_id=2088522087388230, invoice_amount=0.01, notify_id=2022110601222194517088231408219853, fund_bill_list=[{\"amount\":\"0.01\",\"fundChannel\":\"ALIPAYACCOUNT\"}], notify_type=trade_status_sync, trade_status=TRADE_SUCCESS, receipt_amount=0.01, buyer_pay_amount=0.01, app_id=2021003142665707, sign_type=RSA2, seller_id=2088422205183375, gmt_payment=2022-11-06 19:45:17, notify_time=2022-11-06 19:45:17, version=1.0, out_trade_no=166773509925552, total_amount=0.01, trade_no=2022110622001488231448862073, auth_app_id=2021003142665707, buyer_logon_id=204***@qq.com, point_amount=0.00}', '2022-11-06 19:45:12', '2022-11-08 02:38:36', 0);
INSERT INTO `payment_info` (`id`, `out_trade_no`, `order_id`, `payment_type`, `trade_no`, `total_amount`, `subject`, `payment_status`, `callback_time`, `callback_content`, `create_time`, `update_time`, `is_deleted`) VALUES (29, '166788321026098', 40, 1, '2022110822001488231457449981', 0.01, '2022-11-10|北京协和医院|精神疾病科|副主任医师', 2, '2022-11-08 12:53:54', '{gmt_create=2022-11-08 12:53:49, charset=GBK, seller_email=1597307923@qq.com, subject=????, sign=Fjtb8Xno/mzaZwiIMvS81Dw4f7VKlOHp1xjx8SUP+WnxXFNKvmP35DZYz50OSHQVMGyY+/bUtAzy4jc4Pf18QSgHVUdJbJfKMnUn/LpoAy+iKd3AnbWaxZzjFFnGuxr4tN0JKRnbuW9GdGoXymClqIlIMV5OKmJW7nYJP3PVKgB05NtgTfp5n+OmAxcjzXh8BaeAog3h4dkEP8KsLkmSbUZRqdEwBmBGcJ20ni5ETdlquDlHgonaMcKHDKCFBCfbdKjPNYJK59O2wDhGb6oKXIZ46U/8a4UZDtNAta49k1XKLsm63gXhDR04Z+AE/+CPLo7tgvm8x0K/TNkEq4EmWQ==, buyer_id=2088522087388230, invoice_amount=0.01, notify_id=2022110801222125352088231409961364, fund_bill_list=[{\"amount\":\"0.01\",\"fundChannel\":\"ALIPAYACCOUNT\"}], notify_type=trade_status_sync, trade_status=TRADE_SUCCESS, receipt_amount=0.01, buyer_pay_amount=0.01, app_id=2021003142665707, sign_type=RSA2, seller_id=2088422205183375, gmt_payment=2022-11-08 12:53:52, notify_time=2022-11-08 12:53:52, version=1.0, out_trade_no=166788321026098, total_amount=0.01, trade_no=2022110822001488231457449981, auth_app_id=2021003142665707, buyer_logon_id=204***@qq.com, point_amount=0.00}', '2022-11-08 12:53:45', '2022-11-08 12:53:54', 0);
INSERT INTO `payment_info` (`id`, `out_trade_no`, `order_id`, `payment_type`, `trade_no`, `total_amount`, `subject`, `payment_status`, `callback_time`, `callback_content`, `create_time`, `update_time`, `is_deleted`) VALUES (30, '166790806040058', 76, 1, '2022110822001488231457423368', 0.01, '2022-11-13|北京协和医院|精神疾病科|副主任医师', 2, '2022-11-09 19:48:24', '{gmt_create=2022-11-08 19:48:16, charset=GBK, seller_email=1597307923@qq.com, subject=????, sign=nZvVpxpmu005wgm2fZWYh+CHGJ1IuRPRzXTQmfK7e9Cq36nnfkowqEzvVN+q8QUC2xT4M98Io+UBUiIMiTTxEe/EUIMO0T1woe7ZapAtbLynAiIPacHH5X5R/b9iKPbjDx7T52wmg17e06n9k5A3iyosHXU3QFn2DcNeCZ/uJVinbuWWyi4cloemjvGKeoQAZO8BWn0WIFzSrrb/+5z8XIfRgoZEW0YYVj0coVxpKc/lZ3UtBi0n4weyW2FGaIa1Lopg90lsfqCIm54XDXuUpZu5IdKu4cFyzEgeyCIUy7AZuRuUdQu6F/8pRWSoDjctjC26EekvHU90OeqKKdXxAw==, buyer_id=2088522087388230, invoice_amount=0.01, notify_id=2022110801222194820088231412308400, fund_bill_list=[{\"amount\":\"0.01\",\"fundChannel\":\"ALIPAYACCOUNT\"}], notify_type=trade_status_sync, trade_status=TRADE_SUCCESS, receipt_amount=0.01, buyer_pay_amount=0.01, app_id=2021003142665707, sign_type=RSA2, seller_id=2088422205183375, gmt_payment=2022-11-08 19:48:20, notify_time=2022-11-08 19:48:20, version=1.0, out_trade_no=166790806040058, total_amount=0.01, trade_no=2022110822001488231457423368, auth_app_id=2021003142665707, buyer_logon_id=204***@qq.com, point_amount=0.00}', '2022-11-08 19:48:11', '2022-11-09 01:15:06', 0);
INSERT INTO `payment_info` (`id`, `out_trade_no`, `order_id`, `payment_type`, `trade_no`, `total_amount`, `subject`, `payment_status`, `callback_time`, `callback_content`, `create_time`, `update_time`, `is_deleted`) VALUES (31, '166795577768622', 77, 1, '2022110922001488231402194352', 0.01, '2022-11-14|北京协和医院|精神疾病科|医师', 2, '2022-11-09 09:14:40', '{gmt_create=2022-11-09 09:14:33, charset=GBK, seller_email=1597307923@qq.com, subject=????, sign=d1vuJfPElegColA7XdFnD0VfFVt5FPwZDKyCubJvZcMpvgqGsnJWWYygKO7u9miLye0sAVYGK0GbZOgB5j5p7ZjLNRzzhKohbLKEkSODw/GsbRWHyH5r4qmGAQ2UUAgpKtHCbM2Bj7akcsOai1Vg8HRvTMXeLHXwLfCdllxC4N7dlubolChCugWGdbVBjhUlHqfPv+/FYpV4YbFtu+6DPBj8f2xdxXjUZogdKNynGXlIM3yTJYqnuY6E6iAQORmUxRoBvn+aSS2VjY2R0VAnal8IcFyNCshJVNm2X2e/OnZkJBRnyogsiDOeZxOW7ggn68AVKqnK2uef5LbqqeYTQg==, buyer_id=2088522087388230, invoice_amount=0.01, notify_id=2022110901222091438088231413773611, fund_bill_list=[{\"amount\":\"0.01\",\"fundChannel\":\"ALIPAYACCOUNT\"}], notify_type=trade_status_sync, trade_status=TRADE_SUCCESS, receipt_amount=0.01, buyer_pay_amount=0.01, app_id=2021003142665707, sign_type=RSA2, seller_id=2088422205183375, gmt_payment=2022-11-09 09:14:38, notify_time=2022-11-09 09:14:38, version=1.0, out_trade_no=166795577768622, total_amount=0.01, trade_no=2022110922001488231402194352, auth_app_id=2021003142665707, buyer_logon_id=204***@qq.com, point_amount=0.00}', '2022-11-09 09:14:29', '2022-11-09 09:14:40', 0);
COMMIT;

-- ----------------------------
-- Table structure for refund_info
-- ----------------------------
DROP TABLE IF EXISTS `refund_info`;
CREATE TABLE `refund_info` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '编号',
  `out_trade_no` varchar(50) DEFAULT NULL COMMENT '对外业务编号',
  `order_id` bigint DEFAULT NULL COMMENT '订单编号',
  `payment_type` tinyint DEFAULT NULL COMMENT '支付类型（微信 支付宝）',
  `trade_no` varchar(50) DEFAULT NULL COMMENT '交易编号',
  `total_amount` decimal(10,2) DEFAULT NULL COMMENT '退款金额',
  `subject` varchar(200) DEFAULT NULL COMMENT '交易内容',
  `refund_status` tinyint DEFAULT NULL COMMENT '退款状态',
  `callback_content` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci COMMENT '回调信息',
  `callback_time` datetime DEFAULT NULL,
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `is_deleted` tinyint NOT NULL DEFAULT '0' COMMENT '逻辑删除(1:已删除，0:未删除)',
  PRIMARY KEY (`id`),
  KEY `idx_out_trade_no` (`out_trade_no`),
  KEY `idx_order_id` (`order_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3 COMMENT='退款信息表';

-- ----------------------------
-- Records of refund_info
-- ----------------------------
BEGIN;
INSERT INTO `refund_info` (`id`, `out_trade_no`, `order_id`, `payment_type`, `trade_no`, `total_amount`, `subject`, `refund_status`, `callback_content`, `callback_time`, `create_time`, `update_time`, `is_deleted`) VALUES (2, '166773509925552', 36, 1, NULL, NULL, '2022-11-08|北京协和医院|精神疾病科|副主任医师', 2, '{\"body\":\"{\\\"alipay_trade_refund_response\\\":{\\\"code\\\":\\\"10000\\\",\\\"msg\\\":\\\"Success\\\",\\\"buyer_logon_id\\\":\\\"204***@qq.com\\\",\\\"buyer_user_id\\\":\\\"2088522087388230\\\",\\\"fund_change\\\":\\\"N\\\",\\\"gmt_refund_pay\\\":\\\"2022-11-08 10:43:01\\\",\\\"out_trade_no\\\":\\\"166773509925552\\\",\\\"refund_detail_item_list\\\":[{\\\"amount\\\":\\\"0.01\\\",\\\"fund_channel\\\":\\\"ALIPAYACCOUNT\\\"}],\\\"refund_fee\\\":\\\"0.01\\\",\\\"send_back_fee\\\":\\\"0.01\\\",\\\"trade_no\\\":\\\"2022110622001488231448862073\\\"},\\\"sign\\\":\\\"bcQuxObVH5N7eLITxouqjIJU5RDQMhCFciJzxiXLfyvev0tAfN74zAiIu6vZpntk0SZ8sl7BBhAYbfb+qzCCBX6yihawnTkYs41Ovb34goHBLu/156xS9ohXJvrztxhcS86iY9xysmmIoDCHzVNPxQV7pj/PEi+rMXXMxMmxHYATZCzp0mTsrI3W/N+UsANfq7egG1AAFXtdwKJfd9WTVxFWAJxsjnNnaxzcyhxSEd+A+QLNfnVeg/z/UCwXy+FhgeBfIHGgr+Lff0R83Sbge4yuWw9EvKcQ8JhTVarH6fA3rMfNfLg+u+gOjk3lImTVDgz7WkOxFgknF1qgZ3xAaQ==\\\"}\",\"buyerLogonId\":\"204***@qq.com\",\"buyerUserId\":\"2088522087388230\",\"code\":\"10000\",\"errorCode\":\"10000\",\"fundChange\":\"N\",\"gmtRefundPay\":1667875381000,\"msg\":\"Success\",\"outTradeNo\":\"166773509925552\",\"params\":{\"biz_content\":\"{\\\"out_trade_no\\\":\\\"166773509925552\\\",\\\"trade_no\\\":\\\"2022110622001488231448862073\\\",\\\"refund_amount\\\":0.01}\"},\"refundDetailItemList\":[{\"amount\":\"0.01\",\"fundChannel\":\"ALIPAYACCOUNT\"}],\"refundFee\":\"0.01\",\"sendBackFee\":\"0.01\",\"success\":true,\"tradeNo\":\"2022110622001488231448862073\"}', '2022-11-08 10:46:12', '2022-11-08 02:37:25', '2022-11-08 10:36:59', 0);
INSERT INTO `refund_info` (`id`, `out_trade_no`, `order_id`, `payment_type`, `trade_no`, `total_amount`, `subject`, `refund_status`, `callback_content`, `callback_time`, `create_time`, `update_time`, `is_deleted`) VALUES (3, '166773490368653', 35, 1, NULL, NULL, '2022-11-08|北京协和医院|精神疾病科|副主任医师', 2, '{\"body\":\"{\\\"alipay_trade_refund_response\\\":{\\\"code\\\":\\\"10000\\\",\\\"msg\\\":\\\"Success\\\",\\\"buyer_logon_id\\\":\\\"204***@qq.com\\\",\\\"buyer_user_id\\\":\\\"2088522087388230\\\",\\\"fund_change\\\":\\\"Y\\\",\\\"gmt_refund_pay\\\":\\\"2022-11-08 10:54:49\\\",\\\"out_trade_no\\\":\\\"166773490368653\\\",\\\"refund_detail_item_list\\\":[{\\\"amount\\\":\\\"0.01\\\",\\\"fund_channel\\\":\\\"ALIPAYACCOUNT\\\"}],\\\"refund_fee\\\":\\\"0.01\\\",\\\"send_back_fee\\\":\\\"0.01\\\",\\\"trade_no\\\":\\\"2022110622001488231449627387\\\"},\\\"sign\\\":\\\"BXz2fthGG5Bz/0GeorliJDn6aHlhVlHnoFQUh5Q6DllcC1RHfxy+fqEymIS2l4gE3V/GgB2ZaKtHkdqO+k9X6yFwN+R+8wov0Mfow+wEkFpsb0FZ6A4VlZ6dQz+I2VV9YwbyemiG7OcHOxaJS+4mTdHOh9RwpCKQLUI/XxhVB3QDkno5GBOI/hssHBWcQ0DC9a462oxhuh4yGDr5Vf50e579EQ6qu3iKc8oyLXvpl4R+g5TKfS/ldQHKBMdSJYugBJe4C0Zs3xo+dxSjW99qv9Q/iydEuHFVaHc2dW3r+AV8Fk1WPaKF7NNgLlXkoOfkTkeA8Rwa13shyGOKEI2NDg==\\\"}\",\"buyerLogonId\":\"204***@qq.com\",\"buyerUserId\":\"2088522087388230\",\"code\":\"10000\",\"errorCode\":\"10000\",\"fundChange\":\"Y\",\"gmtRefundPay\":1667876089000,\"msg\":\"Success\",\"outTradeNo\":\"166773490368653\",\"params\":{\"biz_content\":\"{\\\"out_trade_no\\\":\\\"166773490368653\\\",\\\"trade_no\\\":\\\"2022110622001488231449627387\\\",\\\"refund_amount\\\":0.01}\"},\"refundDetailItemList\":[{\"amount\":\"0.01\",\"fundChannel\":\"ALIPAYACCOUNT\"}],\"refundFee\":\"0.01\",\"sendBackFee\":\"0.01\",\"success\":true,\"tradeNo\":\"2022110622001488231449627387\"}', '2022-11-08 10:54:50', '2022-11-08 02:52:33', '2022-11-08 10:52:33', 0);
INSERT INTO `refund_info` (`id`, `out_trade_no`, `order_id`, `payment_type`, `trade_no`, `total_amount`, `subject`, `refund_status`, `callback_content`, `callback_time`, `create_time`, `update_time`, `is_deleted`) VALUES (4, '166773415911448', 34, 1, '2022110622001488231448862068', 0.01, '2022-11-08|北京协和医院|精神疾病科|副主任医师', 2, '{\"body\":\"{\\\"alipay_trade_refund_response\\\":{\\\"code\\\":\\\"10000\\\",\\\"msg\\\":\\\"Success\\\",\\\"buyer_logon_id\\\":\\\"204***@qq.com\\\",\\\"buyer_user_id\\\":\\\"2088522087388230\\\",\\\"fund_change\\\":\\\"Y\\\",\\\"gmt_refund_pay\\\":\\\"2022-11-08 11:41:23\\\",\\\"out_trade_no\\\":\\\"166773415911448\\\",\\\"refund_detail_item_list\\\":[{\\\"amount\\\":\\\"0.01\\\",\\\"fund_channel\\\":\\\"ALIPAYACCOUNT\\\"}],\\\"refund_fee\\\":\\\"0.01\\\",\\\"send_back_fee\\\":\\\"0.01\\\",\\\"trade_no\\\":\\\"2022110622001488231448862068\\\"},\\\"sign\\\":\\\"X0zXWz/6ou0b3EMIX1luMGa+9uQKwSQ4X/vX/IkReI4gvrXlbDqYRHGNSLDKE39hy0Q42W1UonVWxd2gnbJHLBA0BBCHVRtPnQJafDFhqCXd8hPJZT5H1ZL1Wae/PaxVV7+TAoZyi+s5SPtpBcbHQ1qrbbf6GKtyZuoeQpwDaN1oF/waG/8cvpRiINJEpbnZH0Fm9KeyWMk0/1x+xt6i5ZrSIABEpn3dgMZL++81KYW36xDZF2lGcqIMob9bjZwlDq7QNHu2AFpgrUnUXGfUnTdP/bFU6dNxxlM8pX1WWcR0ThxFHZcLbs62mWtp6UY7RTJbIoulXEI2xgmC1GLDyQ==\\\"}\",\"buyerLogonId\":\"204***@qq.com\",\"buyerUserId\":\"2088522087388230\",\"code\":\"10000\",\"errorCode\":\"10000\",\"fundChange\":\"Y\",\"gmtRefundPay\":1667878883000,\"msg\":\"Success\",\"outTradeNo\":\"166773415911448\",\"params\":{\"biz_content\":\"{\\\"out_trade_no\\\":\\\"166773415911448\\\",\\\"trade_no\\\":\\\"2022110622001488231448862068\\\",\\\"refund_amount\\\":0.01}\"},\"refundDetailItemList\":[{\"amount\":\"0.01\",\"fundChannel\":\"ALIPAYACCOUNT\"}],\"refundFee\":\"0.01\",\"sendBackFee\":\"0.01\",\"success\":true,\"tradeNo\":\"2022110622001488231448862068\"}', '2022-11-08 11:41:24', '2022-11-08 03:41:21', '2022-11-08 11:41:22', 0);
INSERT INTO `refund_info` (`id`, `out_trade_no`, `order_id`, `payment_type`, `trade_no`, `total_amount`, `subject`, `refund_status`, `callback_content`, `callback_time`, `create_time`, `update_time`, `is_deleted`) VALUES (5, '166788321026098', 40, 1, '2022110822001488231457449981', 0.01, '2022-11-10|北京协和医院|精神疾病科|副主任医师', 2, '{\"body\":\"{\\\"alipay_trade_refund_response\\\":{\\\"code\\\":\\\"10000\\\",\\\"msg\\\":\\\"Success\\\",\\\"buyer_logon_id\\\":\\\"204***@qq.com\\\",\\\"buyer_user_id\\\":\\\"2088522087388230\\\",\\\"fund_change\\\":\\\"Y\\\",\\\"gmt_refund_pay\\\":\\\"2022-11-08 12:55:12\\\",\\\"out_trade_no\\\":\\\"166788321026098\\\",\\\"refund_detail_item_list\\\":[{\\\"amount\\\":\\\"0.01\\\",\\\"fund_channel\\\":\\\"ALIPAYACCOUNT\\\"}],\\\"refund_fee\\\":\\\"0.01\\\",\\\"send_back_fee\\\":\\\"0.01\\\",\\\"trade_no\\\":\\\"2022110822001488231457449981\\\"},\\\"sign\\\":\\\"b1uU5KBsiQqtBUCZ/qSmefvWU5mb1b7+ySLpTCJz3+lviA0MIGBJEpb2JppSsvVV7h3WAAru5oBnxye611RxofpNj9J0ksUYudvV4XdihikRl09R3eNbGZqEW3C4en3wz+DLGA/lO1zdRTSeXa/b2qT7UV9ScAVWy66EjcCpgnMxVNCZlxzFG4oixCEysiyx4y8kMzQLngUGR1qjbRhMzSGPgzTt3mVlkv+jK8VKDdXL1eT5pb4vg3tCeG0kendO0wCxU1o31zk33hCmooguu1CDhJyUkL4kugeY8kYErshBZNbiaoiN+DoaHAKz7AtxQlaeu3PFRrUBrNO/U65iGw==\\\"}\",\"buyerLogonId\":\"204***@qq.com\",\"buyerUserId\":\"2088522087388230\",\"code\":\"10000\",\"errorCode\":\"10000\",\"fundChange\":\"Y\",\"gmtRefundPay\":1667883312000,\"msg\":\"Success\",\"outTradeNo\":\"166788321026098\",\"params\":{\"biz_content\":\"{\\\"out_trade_no\\\":\\\"166788321026098\\\",\\\"trade_no\\\":\\\"2022110822001488231457449981\\\",\\\"refund_amount\\\":0.01}\"},\"refundDetailItemList\":[{\"amount\":\"0.01\",\"fundChannel\":\"ALIPAYACCOUNT\"}],\"refundFee\":\"0.01\",\"sendBackFee\":\"0.01\",\"success\":true,\"tradeNo\":\"2022110822001488231457449981\"}', '2022-11-08 12:55:13', '2022-11-08 04:55:10', '2022-11-08 12:55:10', 0);
INSERT INTO `refund_info` (`id`, `out_trade_no`, `order_id`, `payment_type`, `trade_no`, `total_amount`, `subject`, `refund_status`, `callback_content`, `callback_time`, `create_time`, `update_time`, `is_deleted`) VALUES (6, '166790806040058', 76, 1, '2022110822001488231457423368', 0.01, '2022-11-13|北京协和医院|精神疾病科|副主任医师', 2, '{\"body\":\"{\\\"alipay_trade_refund_response\\\":{\\\"code\\\":\\\"10000\\\",\\\"msg\\\":\\\"Success\\\",\\\"buyer_logon_id\\\":\\\"204***@qq.com\\\",\\\"buyer_user_id\\\":\\\"2088522087388230\\\",\\\"fund_change\\\":\\\"Y\\\",\\\"gmt_refund_pay\\\":\\\"2022-11-08 19:56:47\\\",\\\"out_trade_no\\\":\\\"166790806040058\\\",\\\"refund_detail_item_list\\\":[{\\\"amount\\\":\\\"0.01\\\",\\\"fund_channel\\\":\\\"ALIPAYACCOUNT\\\"}],\\\"refund_fee\\\":\\\"0.01\\\",\\\"send_back_fee\\\":\\\"0.01\\\",\\\"trade_no\\\":\\\"2022110822001488231457423368\\\"},\\\"sign\\\":\\\"g/kT6uJwJSyw2pLWAyK4W04yb8NI1qyPKjB9bs1oKLDz81FYk2/SyuZdV0fdDr176SrEOPSFi4enjj8MTzJVEZEE4Vu/Binl22x2IXC8uxAkCZwu3dp7H3jL4PG+rna8QiiN7WZc4VPlZ7FCEUnTo5KEqmJjf27skaE11wtg1HKdtIFWGkN73CTSRUTt8z4+UBd7whDW4qknYGSnwq/z5Rf2/uajGba+Fm+igYcZvCareSrzVNp72jeLFckiP+hwOLUr+m8cw6WDifz77SKrjR1r6PlAyi5zQGPl6EHM9pLEc6nFG7WED83etM4S8DkTahDv5v1YUIKZf0nQ8+TbYA==\\\"}\",\"buyerLogonId\":\"204***@qq.com\",\"buyerUserId\":\"2088522087388230\",\"code\":\"10000\",\"errorCode\":\"10000\",\"fundChange\":\"Y\",\"gmtRefundPay\":1667908607000,\"msg\":\"Success\",\"outTradeNo\":\"166790806040058\",\"params\":{\"biz_content\":\"{\\\"out_trade_no\\\":\\\"166790806040058\\\",\\\"trade_no\\\":\\\"2022110822001488231457423368\\\",\\\"refund_amount\\\":0.01}\"},\"refundDetailItemList\":[{\"amount\":\"0.01\",\"fundChannel\":\"ALIPAYACCOUNT\"}],\"refundFee\":\"0.01\",\"sendBackFee\":\"0.01\",\"success\":true,\"tradeNo\":\"2022110822001488231457423368\"}', '2022-11-08 19:56:48', '2022-11-08 11:56:46', '2022-11-08 19:56:46', 0);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
